Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	679
Missing cells	2948
Missing cells (%)	22.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	100.9 KiB
Average record size in memory	152.2 B

Variable types

Numeric	13
DateTime	1
Categorical	5

Warnings

`Channel` has constant value "Reclame Aqui"	Constant
`Tickets` has constant value "1"	Constant
`Requester email` has a high cardinality: 679 distinct values	High cardinality
`df_index` is highly correlated with `Requester external ID` and 1 other fields	High correlation
`Requester external ID` is highly correlated with `df_index` and 1 other fields	High correlation
`Requester_ID` is highly correlated with `df_index` and 1 other fields	High correlation
`Volume_CHAT` is highly correlated with `Volume_SOCIAL` and 2 other fields	High correlation
`Volume_SOCIAL` is highly correlated with `Volume_CHAT` and 3 other fields	High correlation
`Tempo_Medio_Chat` is highly correlated with `Volume_SOCIAL` and 1 other fields	High correlation
`Tempo_Medio_Social` is highly correlated with `Volume_CHAT` and 2 other fields	High correlation
`AWT_Chat` is highly correlated with `Volume_SOCIAL` and 1 other fields	High correlation
`CSAT_Rated` is highly correlated with `Volume_CHAT` and 1 other fields	High correlation
`df_index` is highly correlated with `Requester external ID` and 1 other fields	High correlation
`Requester external ID` is highly correlated with `df_index` and 1 other fields	High correlation
`Requester_ID` is highly correlated with `df_index` and 1 other fields	High correlation
`Volume_CHAT` is highly correlated with `Volume_SOCIAL` and 2 other fields	High correlation
`Volume_SOCIAL` is highly correlated with `Volume_CHAT` and 3 other fields	High correlation
`Tempo_Medio_Chat` is highly correlated with `Volume_SOCIAL` and 1 other fields	High correlation
`Tempo_Medio_Social` is highly correlated with `Volume_CHAT` and 3 other fields	High correlation
`AWT_Chat` is highly correlated with `Volume_SOCIAL` and 1 other fields	High correlation
`%NFCR` is highly correlated with `Volume_CHAT` and 1 other fields	High correlation
`%Insatisfação(CSAT)` is highly correlated with `CSAT_Rated`	High correlation
`CSAT_Rated` is highly correlated with `Volume_SOCIAL` and 1 other fields	High correlation
`df_index` is highly correlated with `Requester external ID` and 1 other fields	High correlation
`Requester external ID` is highly correlated with `df_index` and 1 other fields	High correlation
`Requester_ID` is highly correlated with `df_index` and 1 other fields	High correlation
`Volume_CHAT` is highly correlated with `Volume_SOCIAL` and 1 other fields	High correlation
`Volume_SOCIAL` is highly correlated with `Volume_CHAT` and 3 other fields	High correlation
`Tempo_Medio_Chat` is highly correlated with `Volume_SOCIAL` and 1 other fields	High correlation
`Tempo_Medio_Social` is highly correlated with `Volume_CHAT` and 3 other fields	High correlation
`AWT_Chat` is highly correlated with `Volume_SOCIAL` and 1 other fields	High correlation
`%NFCR` is highly correlated with `Tempo_Medio_Social`	High correlation
`%Insatisfação(CSAT)` is highly correlated with `CSAT_Rated`	High correlation
`CSAT_Rated` is highly correlated with `Volume_SOCIAL` and 1 other fields	High correlation
`Volume_SOCIAL` is highly correlated with `Requester_ID` and 4 other fields	High correlation
`Requester_ID` is highly correlated with `Volume_SOCIAL` and 3 other fields	High correlation
`%Insatisfação(CSAT)` is highly correlated with `CSAT_Rated` and 1 other fields	High correlation
`Ticket ID` is highly correlated with `Volume_SOCIAL` and 2 other fields	High correlation
`%NFCR` is highly correlated with `Volume_EMAIL` and 2 other fields	High correlation
`Tempo_Medio_Social` is highly correlated with `Requester_ID` and 4 other fields	High correlation
`Volume_EMAIL` is highly correlated with `%NFCR`	High correlation
`Requester external ID` is highly correlated with `Volume_SOCIAL` and 3 other fields	High correlation
`CSAT_Rated` is highly correlated with `%Insatisfação(CSAT)` and 1 other fields	High correlation
`Volume_CHAT` is highly correlated with `%Insatisfação(CSAT)` and 2 other fields	High correlation
`Assignee email` is highly correlated with `Volume_SOCIAL` and 4 other fields	High correlation
`Tempo_Medio_Email` is highly correlated with `Assignee email`	High correlation
`df_index` is highly correlated with `Volume_SOCIAL` and 3 other fields	High correlation
`Volume_SOCIAL` is highly correlated with `Channel` and 2 other fields	High correlation
`Channel` is highly correlated with `Volume_SOCIAL` and 2 other fields	High correlation
`Tickets` is highly correlated with `Volume_SOCIAL` and 2 other fields	High correlation
`Assignee email` is highly correlated with `Volume_SOCIAL` and 2 other fields	High correlation
`Volume_CHAT` has 261 (38.4%) missing values	Missing
`Volume_EMAIL` has 408 (60.1%) missing values	Missing
`Volume_SOCIAL` has 672 (99.0%) missing values	Missing
`Tempo_Medio_Chat` has 264 (38.9%) missing values	Missing
`Tempo_Medio_Email` has 409 (60.2%) missing values	Missing
`Tempo_Medio_Social` has 672 (99.0%) missing values	Missing
`AWT_Chat` has 262 (38.6%) missing values	Missing
`Requester email` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`Requester external ID` has unique values	Unique
`Ticket ID` has unique values	Unique
`Requester email` has unique values	Unique
`Requester_ID` has unique values	Unique
`%NFCR` has 427 (62.9%) zeros	Zeros
`%Insatisfação(CSAT)` has 562 (82.8%) zeros	Zeros
`CSAT_Rated` has 429 (63.2%) zeros	Zeros

Reproduction

Analysis started	2021-06-15 16:41:28.822579
Analysis finished	2021-06-15 16:42:01.187303
Duration	32.36 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	679
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	463.3460972

Minimum	0
Maximum	932
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	43.9
Q1	239.5
median	455
Q3	692.5
95-th percentile	886.1
Maximum	932
Range	932
Interquartile range (IQR)	453

Descriptive statistics

Standard deviation	266.857943
Coefficient of variation (CV)	0.5759365291
Kurtosis	-1.156358872
Mean	463.3460972
Median Absolute Deviation (MAD)	230
Skewness	0.03692166865
Sum	314612
Variance	71213.16175
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
932	1	0.1%
308	1	0.1%
321	1	0.1%
319	1	0.1%
318	1	0.1%
317	1	0.1%
316	1	0.1%
314	1	0.1%
311	1	0.1%
310	1	0.1%
Other values (669)	669	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%
5	1	0.1%
7	1	0.1%
9	1	0.1%
10	1	0.1%
11	1	0.1%
12	1	0.1%

Value	Count	Frequency (%)
932	1	0.1%
930	1	0.1%
929	1	0.1%
928	1	0.1%
927	1	0.1%
926	1	0.1%
924	1	0.1%
923	1	0.1%
922	1	0.1%
920	1	0.1%

Requester external ID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	679
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8347895.549

Minimum	21593
Maximum	19066870
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	21593
5-th percentile	453050.4
Q1	3568784
median	7780143
Q3	13384518.5
95-th percentile	17118987.9
Maximum	19066870
Range	19045277
Interquartile range (IQR)	9815734.5

Descriptive statistics

Standard deviation	5521532.082
Coefficient of variation (CV)	0.6614280269
Kurtosis	-1.183382488
Mean	8347895.549
Median Absolute Deviation (MAD)	4579825
Skewness	0.1897955962
Sum	5668221078
Variance	3.048731653 × 10¹³
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8863733	1	0.1%
5089973	1	0.1%
7940867	1	0.1%
8140532	1	0.1%
18525146	1	0.1%
10540509	1	0.1%
931164	1	0.1%
17050426	1	0.1%
6179523	1	0.1%
14226811	1	0.1%
Other values (669)	669	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
21593	1	0.1%
30084	1	0.1%
47027	1	0.1%
54194	1	0.1%
56234	1	0.1%
57350	1	0.1%
58058	1	0.1%
58246	1	0.1%
67449	1	0.1%
81043	1	0.1%

Value	Count	Frequency (%)
19066870	1	0.1%
18934000	1	0.1%
18868795	1	0.1%
18845344	1	0.1%
18838144	1	0.1%
18814467	1	0.1%
18685771	1	0.1%
18685162	1	0.1%
18655961	1	0.1%
18640265	1	0.1%

Ticket created - Date
Date

Distinct	113
Distinct (%)	16.6%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

Minimum	2021-01-04 00:00:00
Maximum	2021-06-10 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Channel
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

Reclame Aqui	679

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	8148
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Reclame Aqui
2nd row	Reclame Aqui
3rd row	Reclame Aqui
4th row	Reclame Aqui
5th row	Reclame Aqui

Common Values

Value	Count	Frequency (%)
Reclame Aqui	679	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
aqui	679	50.0%
reclame	679	50.0%

Most occurring characters

Value	Count	Frequency (%)
e	1358	16.7%
R	679	8.3%
c	679	8.3%
l	679	8.3%
a	679	8.3%
m	679	8.3%
	679	8.3%
A	679	8.3%
q	679	8.3%
u	679	8.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6111	75.0%
Uppercase Letter	1358	16.7%
Space Separator	679	8.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1358	22.2%
c	679	11.1%
l	679	11.1%
a	679	11.1%
m	679	11.1%
q	679	11.1%
u	679	11.1%
i	679	11.1%

Uppercase Letter

Value	Count	Frequency (%)
R	679	50.0%
A	679	50.0%

Space Separator

Value	Count	Frequency (%)
	679	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7469	91.7%
Common	679	8.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1358	18.2%
R	679	9.1%
c	679	9.1%
l	679	9.1%
a	679	9.1%
m	679	9.1%
A	679	9.1%
q	679	9.1%
u	679	9.1%
i	679	9.1%

Common

Value	Count	Frequency (%)
	679	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8148	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1358	16.7%
R	679	8.3%
c	679	8.3%
l	679	8.3%
a	679	8.3%
m	679	8.3%
	679	8.3%
A	679	8.3%
q	679	8.3%
u	679	8.3%

Ticket ID
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	679
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3765880.471

Minimum	3459738
Maximum	4080394
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	3459738
5-th percentile	3521072.3
Q1	3615320.5
median	3757266
Q3	3922106.5
95-th percentile	4017061.3
Maximum	4080394
Range	620656
Interquartile range (IQR)	306786

Descriptive statistics

Standard deviation	169678.3309
Coefficient of variation (CV)	0.04505674893
Kurtosis	-1.351913809
Mean	3765880.471
Median Absolute Deviation (MAD)	153313
Skewness	0.03236582552
Sum	2557032840
Variance	2.879073597 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3706936	1	0.1%
3946843	1	0.1%
3817831	1	0.1%
3516774	1	0.1%
3866155	1	0.1%
3634532	1	0.1%
3496291	1	0.1%
3830113	1	0.1%
3855700	1	0.1%
3951549	1	0.1%
Other values (669)	669	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3459738	1	0.1%
3462433	1	0.1%
3473530	1	0.1%
3473850	1	0.1%
3474427	1	0.1%
3474659	1	0.1%
3485298	1	0.1%
3489464	1	0.1%
3489502	1	0.1%
3492398	1	0.1%

Value	Count	Frequency (%)
4080394	1	0.1%
4078417	1	0.1%
4078047	1	0.1%
4071584	1	0.1%
4071351	1	0.1%
4069621	1	0.1%
4062549	1	0.1%
4062341	1	0.1%
4058409	1	0.1%
4058303	1	0.1%

Assignee email
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	25
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

kaique.barbosa@gympass.com	160
suellen.franco+core@gympass.com	121
danielle.hernandes@gympass.com	117
luciana.melo@gympass.com	79
barbara.priscila@gympass.com	67
Other values (20)	135

Length

Max length	31
Median length	27
Mean length	27.70397644
Min length	23

Characters and Unicode

Total characters	18811
Distinct characters	29
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	1.6%

Sample

1st row	kaique.barbosa@gympass.com
2nd row	luciana.melo@gympass.com
3rd row	anderson.santos@gympass.com
4th row	gabriel.almeida@gympass.com
5th row	luciana.melo@gympass.com

Common Values

Value	Count	Frequency (%)
kaique.barbosa@gympass.com	160	23.6%
suellen.franco+core@gympass.com	121	17.8%
danielle.hernandes@gympass.com	117	17.2%
luciana.melo@gympass.com	79	11.6%
barbara.priscila@gympass.com	67	9.9%
anderson.santos@gympass.com	60	8.8%
gabriel.almeida@gympass.com	30	4.4%
elizabete.damiao@gympass.com	14	2.1%
caroline.roberto@gympass.com	5	0.7%
aline.colombo@gympass.com	5	0.7%
Other values (15)	21	3.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
kaique.barbosa@gympass.com	160	23.6%
suellen.franco+core@gympass.com	121	17.8%
danielle.hernandes@gympass.com	117	17.2%
luciana.melo@gympass.com	79	11.6%
barbara.priscila@gympass.com	67	9.9%
anderson.santos@gympass.com	60	8.8%
gabriel.almeida@gympass.com	30	4.4%
elizabete.damiao@gympass.com	14	2.1%
caroline.roberto@gympass.com	5	0.7%
aline.colombo@gympass.com	5	0.7%
Other values (15)	21	3.1%

Most occurring characters

Value	Count	Frequency (%)
a	2245	11.9%
s	2024	10.8%
m	1493	7.9%
.	1357	7.2%
o	1347	7.2%
e	1271	6.8%
c	1088	5.8%
n	883	4.7%
r	847	4.5%
l	802	4.3%
Other values (19)	5454	29.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	16651	88.5%
Other Punctuation	2036	10.8%
Math Symbol	121	0.6%
Connector Punctuation	2	< 0.1%
Decimal Number	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2245	13.5%
s	2024	12.2%
m	1493	9.0%
o	1347	8.1%
e	1271	7.6%
c	1088	6.5%
n	883	5.3%
r	847	5.1%
l	802	4.8%
p	747	4.5%
Other values (14)	3904	23.4%

Other Punctuation

Value	Count	Frequency (%)
.	1357	66.7%
@	679	33.3%

Math Symbol

Value	Count	Frequency (%)
+	121	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	2	100.0%

Decimal Number

Value	Count	Frequency (%)
1	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16651	88.5%
Common	2160	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2245	13.5%
s	2024	12.2%
m	1493	9.0%
o	1347	8.1%
e	1271	7.6%
c	1088	6.5%
n	883	5.3%
r	847	5.1%
l	802	4.8%
p	747	4.5%
Other values (14)	3904	23.4%

Common

Value	Count	Frequency (%)
.	1357	62.8%
@	679	31.4%
+	121	5.6%
_	2	0.1%
1	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18811	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	2245	11.9%
s	2024	10.8%
m	1493	7.9%
.	1357	7.2%
o	1347	7.2%
e	1271	6.8%
c	1088	5.8%
n	883	4.7%
r	847	4.5%
l	802	4.3%
Other values (19)	5454	29.0%

Requester email
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	679
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

rafaela.almeida@facc.ufjf.br	1
gustavo.hocarvalho@hsl.org.br	1
rpereira.png@gmail.com	1
ka.erika2@gmail.com	1
nolive22@ford.com	1
Other values (674)	674

Length

Max length	67
Median length	25
Mean length	25.04565538
Min length	12

Characters and Unicode

Total characters	17006
Distinct characters	40
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	679 ?
Unique (%)	100.0%

Sample

1st row	joabinho99@hotmail.com
2nd row	camila.almeida@unilever.com
3rd row	flashlav@gmail.com
4th row	nancy.jikihara@voith.com
5th row	erikabazilio19@gmail.com

Common Values

Value	Count	Frequency (%)
rafaela.almeida@facc.ufjf.br	1	0.1%
gustavo.hocarvalho@hsl.org.br	1	0.1%
rpereira.png@gmail.com	1	0.1%
ka.erika2@gmail.com	1	0.1%
nolive22@ford.com	1	0.1%
nilsonmaesta@gmail.com	1	0.1%
mirna.folco@fundacaorenova.org	1	0.1%
alves3392@hotmail.com	1	0.1%
guilhermemoura403@gmail.com	1	0.1%
talita.esperandio@localiza.com	1	0.1%
Other values (669)	669	98.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
rafaela.almeida@facc.ufjf.br	1	0.1%
gustavo.hocarvalho@hsl.org.br	1	0.1%
rpereira.png@gmail.com	1	0.1%
ka.erika2@gmail.com	1	0.1%
nolive22@ford.com	1	0.1%
nilsonmaesta@gmail.com	1	0.1%
mirna.folco@fundacaorenova.org	1	0.1%
alves3392@hotmail.com	1	0.1%
guilhermemoura403@gmail.com	1	0.1%
talita.esperandio@localiza.com	1	0.1%
Other values (669)	669	98.5%

Most occurring characters

Value	Count	Frequency (%)
a	1904	11.2%
o	1668	9.8%
m	1363	8.0%
i	1257	7.4%
.	1126	6.6%
l	1061	6.2%
c	1028	6.0%
r	913	5.4%
e	868	5.1%
@	679	4.0%
Other values (30)	5139	30.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14636	86.1%
Other Punctuation	1805	10.6%
Decimal Number	457	2.7%
Connector Punctuation	62	0.4%
Dash Punctuation	46	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1904	13.0%
o	1668	11.4%
m	1363	9.3%
i	1257	8.6%
l	1061	7.2%
c	1028	7.0%
r	913	6.2%
e	868	5.9%
s	639	4.4%
n	610	4.2%
Other values (16)	3325	22.7%

Decimal Number

Value	Count	Frequency (%)
1	79	17.3%
0	67	14.7%
2	61	13.3%
9	48	10.5%
8	41	9.0%
3	38	8.3%
4	34	7.4%
5	33	7.2%
6	29	6.3%
7	27	5.9%

Other Punctuation

Value	Count	Frequency (%)
.	1126	62.4%
@	679	37.6%

Connector Punctuation

Value	Count	Frequency (%)
_	62	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	46	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14636	86.1%
Common	2370	13.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1904	13.0%
o	1668	11.4%
m	1363	9.3%
i	1257	8.6%
l	1061	7.2%
c	1028	7.0%
r	913	6.2%
e	868	5.9%
s	639	4.4%
n	610	4.2%
Other values (16)	3325	22.7%

Common

Value	Count	Frequency (%)
.	1126	47.5%
@	679	28.6%
1	79	3.3%
0	67	2.8%
_	62	2.6%
2	61	2.6%
9	48	2.0%
-	46	1.9%
8	41	1.7%
3	38	1.6%
Other values (4)	123	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17006	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1904	11.2%
o	1668	9.8%
m	1363	8.0%
i	1257	7.4%
.	1126	6.6%
l	1061	6.2%
c	1028	6.0%
r	913	5.4%
e	868	5.1%
@	679	4.0%
Other values (30)	5139	30.2%

Tickets
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

1	679

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	679
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	679	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	679	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	679	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	679	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	679	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	679	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	679	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	679	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	679	100.0%

Requester_ID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	679
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8347895.549

Minimum	21593
Maximum	19066870
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	21593
5-th percentile	453050.4
Q1	3568784
median	7780143
Q3	13384518.5
95-th percentile	17118987.9
Maximum	19066870
Range	19045277
Interquartile range (IQR)	9815734.5

Descriptive statistics

Standard deviation	5521532.082
Coefficient of variation (CV)	0.6614280269
Kurtosis	-1.183382488
Mean	8347895.549
Median Absolute Deviation (MAD)	4579825
Skewness	0.1897955962
Sum	5668221078
Variance	3.048731653 × 10¹³
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8366164	1	0.1%
5291346	1	0.1%
10114398	1	0.1%
13774018	1	0.1%
931164	1	0.1%
1216550	1	0.1%
7842137	1	0.1%
3350869	1	0.1%
12527146	1	0.1%
9139539	1	0.1%
Other values (669)	669	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
21593	1	0.1%
30084	1	0.1%
47027	1	0.1%
54194	1	0.1%
56234	1	0.1%
57350	1	0.1%
58058	1	0.1%
58246	1	0.1%
67449	1	0.1%
81043	1	0.1%

Value	Count	Frequency (%)
19066870	1	0.1%
18934000	1	0.1%
18868795	1	0.1%
18845344	1	0.1%
18838144	1	0.1%
18814467	1	0.1%
18685771	1	0.1%
18685162	1	0.1%
18655961	1	0.1%
18640265	1	0.1%

Volume_CHAT
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	12
Distinct (%)	2.9%
Missing	261
Missing (%)	38.4%
Infinite	0
Infinite (%)	0.0%
Mean	2.294258373

Minimum	0
Maximum	16
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	6
Maximum	16
Range	16
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.919736081
Coefficient of variation (CV)	0.8367567066
Kurtosis	11.45467045
Mean	2.294258373
Median Absolute Deviation (MAD)	1
Skewness	2.668019466
Sum	959
Variance	3.685386619
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	203	29.9%
2	76	11.2%
3	62	9.1%
4	32	4.7%
5	21	3.1%
7	6	0.9%
6	6	0.9%
8	5	0.7%
9	4	0.6%
15	1	0.1%
Other values (2)	2	0.3%
(Missing)	261	38.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
1	203	29.9%
2	76	11.2%
3	62	9.1%
4	32	4.7%
5	21	3.1%
6	6	0.9%
7	6	0.9%
8	5	0.7%
9	4	0.6%

Value	Count	Frequency (%)
16	1	0.1%
15	1	0.1%
9	4	0.6%
8	5	0.7%
7	6	0.9%
6	6	0.9%
5	21	3.1%
4	32	4.7%
3	62	9.1%
2	76	11.2%

Volume_EMAIL
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	8
Distinct (%)	3.0%
Missing	408
Missing (%)	60.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.586715867

Minimum	1
Maximum	11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3.5
Maximum	11
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.185892658
Coefficient of variation (CV)	0.7473881636
Kurtosis	21.35105228
Mean	1.586715867
Median Absolute Deviation (MAD)	0
Skewness	3.879229103
Sum	430
Variance	1.406341397
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	179	26.4%
2	59	8.7%
3	19	2.8%
4	8	1.2%
5	2	0.3%
8	2	0.3%
7	1	0.1%
11	1	0.1%
(Missing)	408	60.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	179	26.4%
2	59	8.7%
3	19	2.8%
4	8	1.2%
5	2	0.3%
7	1	0.1%
8	2	0.3%
11	1	0.1%

Value	Count	Frequency (%)
11	1	0.1%
8	2	0.3%
7	1	0.1%
5	2	0.3%
4	8	1.2%
3	19	2.8%
2	59	8.7%
1	179	26.4%

Volume_SOCIAL
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	42.9%
Missing	672
Missing (%)	99.0%
Memory size	5.4 KiB

1.0	4
3.0	2
2.0	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	21
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	14.3%

Sample

1st row	1.0
2nd row	3.0
3rd row	3.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	4	0.6%
3.0	2	0.3%
2.0	1	0.1%
(Missing)	672	99.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1.0	4	57.1%
3.0	2	28.6%
2.0	1	14.3%

Most occurring characters

Value	Count	Frequency (%)
.	7	33.3%
0	7	33.3%
1	4	19.0%
3	2	9.5%
2	1	4.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	14	66.7%
Other Punctuation	7	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	7	50.0%
1	4	28.6%
3	2	14.3%
2	1	7.1%

Other Punctuation

Value	Count	Frequency (%)
.	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	21	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	7	33.3%
0	7	33.3%
1	4	19.0%
3	2	9.5%
2	1	4.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	7	33.3%
0	7	33.3%
1	4	19.0%
3	2	9.5%
2	1	4.8%

Tempo_Medio_Chat
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	376
Distinct (%)	90.6%
Missing	264
Missing (%)	38.9%
Infinite	0
Infinite (%)	0.0%
Mean	1496.860241

Minimum	15
Maximum	6115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	15
5-th percentile	451.9
Q1	923
median	1324
Q3	1874
95-th percentile	3055.8
Maximum	6115
Range	6100
Interquartile range (IQR)	951

Descriptive statistics

Standard deviation	848.0170446
Coefficient of variation (CV)	0.5665305427
Kurtosis	3.679638398
Mean	1496.860241
Median Absolute Deviation (MAD)	446
Skewness	1.51206775
Sum	621197
Variance	719132.908
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1100	3	0.4%
1592	3	0.4%
415	3	0.4%
857	2	0.3%
1455	2	0.3%
1723	2	0.3%
2769	2	0.3%
1959	2	0.3%
1407	2	0.3%
1409	2	0.3%
Other values (366)	392	57.7%
(Missing)	264	38.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
15	1	0.1%
57	1	0.1%
78	1	0.1%
244	1	0.1%
263	1	0.1%
278	1	0.1%
322	1	0.1%
354	1	0.1%
377	1	0.1%
382	1	0.1%

Value	Count	Frequency (%)
6115	1	0.1%
5271	1	0.1%
4815	1	0.1%
4390	1	0.1%
4249	1	0.1%
4108	1	0.1%
4013	1	0.1%
3970	1	0.1%
3958	1	0.1%
3841	1	0.1%

Tempo_Medio_Email
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	266
Distinct (%)	98.5%
Missing	409
Missing (%)	60.2%
Infinite	0
Infinite (%)	0.0%
Mean	12222.52222

Minimum	1470
Maximum	134314
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	1470
5-th percentile	3069.1
Q1	5652.75
median	8976.5
Q3	15106
95-th percentile	29221.9
Maximum	134314
Range	132844
Interquartile range (IQR)	9453.25

Descriptive statistics

Standard deviation	12276.98074
Coefficient of variation (CV)	1.004455587
Kurtosis	40.68030281
Mean	12222.52222
Median Absolute Deviation (MAD)	4363.5
Skewness	5.088451653
Sum	3300081
Variance	150724256.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7892	2	0.3%
6891	2	0.3%
4262	2	0.3%
15843	2	0.3%
3296	1	0.1%
5458	1	0.1%
22396	1	0.1%
21026	1	0.1%
10458	1	0.1%
18102	1	0.1%
Other values (256)	256	37.7%
(Missing)	409	60.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1470	1	0.1%
1634	1	0.1%
1932	1	0.1%
2111	1	0.1%
2172	1	0.1%
2183	1	0.1%
2244	1	0.1%
2525	1	0.1%
2569	1	0.1%
2640	1	0.1%

Value	Count	Frequency (%)
134314	1	0.1%
80964	1	0.1%
65903	1	0.1%
57865	1	0.1%
43397	1	0.1%
38705	1	0.1%
38520	1	0.1%
34728	1	0.1%
32963	1	0.1%
32724	1	0.1%

Tempo_Medio_Social
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	7
Distinct (%)	100.0%
Missing	672
Missing (%)	99.0%
Infinite	0
Infinite (%)	0.0%
Mean	15062.14286

Minimum	5197
Maximum	40679
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	5197
5-th percentile	5217.1
Q1	5633
median	7483
Q3	20405
95-th percentile	35264.6
Maximum	40679
Range	35482
Interquartile range (IQR)	14772

Descriptive statistics

Standard deviation	13267.00173
Coefficient of variation (CV)	0.8808176799
Kurtosis	1.570188707
Mean	15062.14286
Median Absolute Deviation (MAD)	2286
Skewness	1.418327471
Sum	105435
Variance	176013334.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
5197	1	0.1%
40679	1	0.1%
7483	1	0.1%
5264	1	0.1%
6002	1	0.1%
22631	1	0.1%
18179	1	0.1%
(Missing)	672	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5197	1	0.1%
5264	1	0.1%
6002	1	0.1%
7483	1	0.1%
18179	1	0.1%
22631	1	0.1%
40679	1	0.1%

Value	Count	Frequency (%)
40679	1	0.1%
22631	1	0.1%
18179	1	0.1%
7483	1	0.1%
6002	1	0.1%
5264	1	0.1%
5197	1	0.1%

AWT_Chat
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	178
Distinct (%)	42.7%
Missing	262
Missing (%)	38.6%
Infinite	0
Infinite (%)	0.0%
Mean	144.8009592

Minimum	5
Maximum	1981
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	5
5-th percentile	8
Q1	17
median	35
Q3	109
95-th percentile	772.2
Maximum	1981
Range	1976
Interquartile range (IQR)	92

Descriptive statistics

Standard deviation	286.7212634
Coefficient of variation (CV)	1.980106105
Kurtosis	15.08869612
Mean	144.8009592
Median Absolute Deviation (MAD)	24
Skewness	3.604342587
Sum	60382
Variance	82209.08288
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	14	2.1%
17	13	1.9%
11	12	1.8%
19	11	1.6%
13	10	1.5%
9	10	1.5%
12	9	1.3%
24	9	1.3%
7	9	1.3%
14	8	1.2%
Other values (168)	312	45.9%
(Missing)	262	38.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	2	0.3%
6	7	1.0%
7	9	1.3%
8	14	2.1%
9	10	1.5%
10	7	1.0%
11	12	1.8%
12	9	1.3%
13	10	1.5%
14	8	1.2%

Value	Count	Frequency (%)
1981	1	0.1%
1810	2	0.3%
1750	1	0.1%
1691	1	0.1%
1479	1	0.1%
1208	1	0.1%
1191	1	0.1%
1011	1	0.1%
997	1	0.1%
968	1	0.1%

%NFCR
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	24
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1935250076

Minimum	0
Maximum	1
Zeros	427
Zeros (%)	62.9%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.4
95-th percentile	0.75
Maximum	1
Range	1
Interquartile range (IQR)	0.4

Descriptive statistics

Standard deviation	0.2878945825
Coefficient of variation (CV)	1.48763504
Kurtosis	0.6655898517
Mean	0.1935250076
Median Absolute Deviation (MAD)	0
Skewness	1.301673725
Sum	131.4034802
Variance	0.08288329061
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	427	62.9%
0.5	82	12.1%
0.3333333333	40	5.9%
1	30	4.4%
0.6666666667	19	2.8%
0.25	17	2.5%
0.2	14	2.1%
0.75	12	1.8%
0.4	10	1.5%
0.6	4	0.6%
Other values (14)	24	3.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	427	62.9%
0.1666666667	3	0.4%
0.2	14	2.1%
0.25	17	2.5%
0.3	2	0.3%
0.3333333333	40	5.9%
0.375	2	0.3%
0.4	10	1.5%
0.4285714286	3	0.4%
0.4444444444	1	0.1%

Value	Count	Frequency (%)
1	30	4.4%
0.8	2	0.3%
0.7777777778	1	0.1%
0.75	12	1.8%
0.7142857143	1	0.1%
0.7	1	0.1%
0.6666666667	19	2.8%
0.6470588235	1	0.1%
0.6363636364	1	0.1%
0.6	4	0.6%

%Insatisfação(CSAT)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	8
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1507250481

Minimum	0
Maximum	1
Zeros	562
Zeros (%)	82.8%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3438570259
Coefficient of variation (CV)	2.281352901
Kurtosis	1.994993866
Mean	0.1507250481
Median Absolute Deviation (MAD)	0
Skewness	1.956843913
Sum	102.3423077
Variance	0.1182376542
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	562	82.8%
1	89	13.1%
0.5	20	2.9%
0.3333333333	4	0.6%
0.6923076923	1	0.1%
0.4	1	0.1%
0.6666666667	1	0.1%
0.25	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	562	82.8%
0.25	1	0.1%
0.3333333333	4	0.6%
0.4	1	0.1%
0.5	20	2.9%
0.6666666667	1	0.1%
0.6923076923	1	0.1%
1	89	13.1%

Value	Count	Frequency (%)
1	89	13.1%
0.6923076923	1	0.1%
0.6666666667	1	0.1%
0.5	20	2.9%
0.4	1	0.1%
0.3333333333	4	0.6%
0.25	1	0.1%
0	562	82.8%

CSAT_Rated
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	8
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5375552283

Minimum	0
Maximum	13
Zeros	429
Zeros (%)	63.2%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	13
Range	13
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9676114356
Coefficient of variation (CV)	1.800022369
Kurtosis	44.21342647
Mean	0.5375552283
Median Absolute Deviation (MAD)	0
Skewness	4.659882536
Sum	365
Variance	0.9362718904
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	429	63.2%
1	175	25.8%
2	60	8.8%
3	6	0.9%
5	5	0.7%
4	2	0.3%
13	1	0.1%
6	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	429	63.2%
1	175	25.8%
2	60	8.8%
3	6	0.9%
4	2	0.3%
5	5	0.7%
6	1	0.1%
13	1	0.1%

Value	Count	Frequency (%)
13	1	0.1%
6	1	0.1%
5	5	0.7%
4	2	0.3%
3	6	0.9%
2	60	8.8%
1	175	25.8%
0	429	63.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	Requester external ID	Ticket created - Date	Channel	Ticket ID	Assignee email	Requester email	Tickets	Requester_ID	Volume_CHAT	Volume_EMAIL	Volume_SOCIAL	Tempo_Medio_Chat	Tempo_Medio_Email	Tempo_Medio_Social	AWT_Chat	%NFCR	%Insatisfação(CSAT)	CSAT_Rated
0	0	21593.0	2021-05-10	Reclame Aqui	3961927	kaique.barbosa@gympass.com	joabinho99@hotmail.com	1	21593	NaN	2.0	NaN	NaN	13881.0	NaN	NaN	0.500000	0.0	0
1	2	30084.0	2021-05-06	Reclame Aqui	3952516	luciana.melo@gympass.com	camila.almeida@unilever.com	1	30084	NaN	2.0	NaN	NaN	9067.0	NaN	NaN	0.666667	0.0	0
2	3	47027.0	2021-02-19	Reclame Aqui	3670243	anderson.santos@gympass.com	flashlav@gmail.com	1	47027	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.000000	0.0	0
3	4	54194.0	2021-03-22	Reclame Aqui	3795980	gabriel.almeida@gympass.com	nancy.jikihara@voith.com	1	54194	1.0	1.0	NaN	1066.0	57865.0	NaN	169.0	0.500000	1.0	1
4	5	56234.0	2021-04-16	Reclame Aqui	3882995	luciana.melo@gympass.com	erikabazilio19@gmail.com	1	56234	1.0	NaN	NaN	1100.0	NaN	NaN	10.0	0.000000	1.0	1
5	7	57350.0	2021-04-01	Reclame Aqui	3831206	luciana.melo@gympass.com	tatiane.jesus@taesa.com.br	1	57350	2.0	NaN	NaN	718.0	NaN	NaN	53.0	0.000000	0.0	0
6	9	58058.0	2021-02-04	Reclame Aqui	3610902	danielle.hernandes@gympass.com	andreassenco@gmail.com	1	58058	1.0	NaN	NaN	440.0	NaN	NaN	37.0	0.000000	0.0	0
7	10	58246.0	2021-03-04	Reclame Aqui	3726711	suellen.franco+core@gympass.com	wasgoncalves@gmail.com	1	58246	NaN	NaN	1.0	NaN	NaN	18179.0	NaN	0.000000	0.0	0
8	11	67449.0	2021-02-10	Reclame Aqui	3634981	suellen.franco+core@gympass.com	babixf@hotmail.com	1	67449	1.0	NaN	NaN	392.0	NaN	NaN	197.0	0.000000	0.0	0
9	12	81043.0	2021-05-12	Reclame Aqui	3972597	danielle.hernandes@gympass.com	daniel.saggese@gmail.com	1	81043	NaN	3.0	NaN	NaN	6990.0	NaN	NaN	0.333333	1.0	1

Last rows

	df_index	Requester external ID	Ticket created - Date	Channel	Ticket ID	Assignee email	Requester email	Tickets	Requester_ID	Volume_CHAT	Volume_EMAIL	Volume_SOCIAL	Tempo_Medio_Chat	Tempo_Medio_Email	Tempo_Medio_Social	AWT_Chat	%NFCR	%Insatisfação(CSAT)	CSAT_Rated
669	920	18640265.0	2021-04-27	Reclame Aqui	3915302	luciana.melo@gympass.com	sneiva09@hotmail.com	1	18640265	NaN	1.0	NaN	NaN	3829.0	NaN	NaN	0.50	0.00	0
670	922	18655961.0	2021-04-15	Reclame Aqui	3880457	danielle.hernandes@gympass.com	ft.oportunidades@gmail.com	1	18655961	1.0	NaN	NaN	3711.0	NaN	NaN	19.0	0.00	1.00	1
671	923	18685162.0	2021-05-19	Reclame Aqui	3996381	barbara.priscila@gympass.com	thales.berdu@bayer.com	1	18685162	1.0	2.0	NaN	1013.0	12767.0	NaN	1691.0	0.50	1.00	1
672	924	18685771.0	2021-05-18	Reclame Aqui	3993205	kaique.barbosa@gympass.com	andre.martins@modal.com.br	1	18685771	5.0	1.0	NaN	962.0	11879.0	NaN	332.0	0.50	0.25	4
673	926	18814467.0	2021-05-24	Reclame Aqui	4012508	barbara.priscila@gympass.com	flaviaduarte@vooal.com	1	18814467	1.0	3.0	NaN	1333.0	6891.0	NaN	14.0	0.25	0.00	0
674	927	18838144.0	2021-05-04	Reclame Aqui	3942142	kaique.barbosa@gympass.com	hugovinicius93@hotmail.com	1	18838144	1.0	NaN	NaN	702.0	NaN	NaN	1750.0	0.00	1.00	1
675	928	18845344.0	2021-05-11	Reclame Aqui	3969697	luciana.melo@gympass.com	wendel.guedes@itau-unibanco.com.br	1	18845344	5.0	NaN	NaN	1647.0	NaN	NaN	24.0	1.00	1.00	2
676	929	18868795.0	2021-05-06	Reclame Aqui	3952988	barbara.priscila@gympass.com	rafael@vaozmedia.com.br	1	18868795	NaN	1.0	NaN	NaN	3787.0	NaN	NaN	0.00	0.00	0
677	930	18934000.0	2021-05-14	Reclame Aqui	3982276	barbara.priscila@gympass.com	contato.athleticpower@gmail.com	1	18934000	NaN	7.0	NaN	NaN	10299.0	NaN	NaN	0.50	0.00	0
678	932	19066870.0	2021-01-07	Reclame Aqui	3489502	suellen.franco+core@gympass.com	lucashaddadf@gmail.com	1	19066870	1.0	1.0	NaN	1717.0	2931.0	NaN	38.0	0.00	0.00	0

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Other Punctuation

Math Symbol

Connector Punctuation

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Other Punctuation

Connector Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions